-------------------------------------sql 代码-----------------------------
insert into cux_com_modal (I_MODAL, I_MODAL_DAD, S_MODAL, S_MENU, S_NAME, S_ICO, S_BUSINESS, S_URL, I_ISLAST, I_VIS, C_STATE, I_UPDATE, I_SYSTYPE, S_PARAM, I_ISCMD)
values (9280017, 9100000, '280199', null, '${menuName2}', null, '${systemCode}Business', '/fhxherp/console/view/report/${systemCode?uncap_first}.html', null, null, 'A', 20191105150551, 0, null, 0);

insert into cux_excel_opt_funs (S_FUNS, S_NAME, S_RESULTSQL, S_MODAL, TYPE, S_MODALNAME, CREATION_DATE, LAST_UPDATE_DATE)
values ('${systemCode?upper_case}', '${menuName2}', null, 'REPORT', '10', '报表查询', to_date('25-05-2020', 'dd-mm-yyyy'), null);

-------------------------------------contraoller 代码-----------------------------
@RequestMapping("${qryUrl}")
@ResponseResult
public Object qry${systemCode}Page()   {
    return  xxxxService.qry${systemCode}Page(RequestUtils.getParams());
}

-------------------------------------serevice 代码-----------------------------
@Override
public ResultMap qry${systemCode}Page(Map params)  {
    return ResultMap.ok(xxxxDao.qry${systemCode}Page(params,this.getPageParm(params)));
}

-------------------------------------dao 代码-----------------------------
@Override
public Page qry${systemCode}Page(Map params,PageParam pageParam)  {
    StringBuilder sql = new StringBuilder(128);
    sql.append("${sql}");
    List paramList = new ArrayList();
<#list paramsList as po>
    String ${po.columnName} = Str(params.get("${po.columnName}"));
    if (StringUtils.isNotBlank(${po.columnName})){
    <#if po.queryParamType=="all">
        sql.append(" AND csi.${po.columnName} = ? ");
        paramList.add(${po.columnName});
    <#elseif po.queryParamType=="like" >
        sql.append(" AND csi.${po.columnName} like ? ");
        paramList.add("%"+${po.columnName}+"%");
    <#else>
    </#if>
    }
</#list>

    return pagedQuery(sql.toString(), "", "", "", pageParam.getPageNo(), pageParam.getPageSize(), paramList);
}